﻿CREATE TABLE [dbo].[Notice] (
    [id]            INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [NId]           UNIQUEIDENTIFIER CONSTRAINT [DF_Notice_NId] DEFAULT (newid()) NULL,
    [Fid]           INT              NULL,
    [Title]         NVARCHAR (200)   NULL,
    [Content]       VARCHAR (MAX)    NULL,
    [UpName]        NVARCHAR (20)    NULL,
    [IsAll]         BIT              NULL,
    [IsDing]        BIT              NULL,
    [CreateTime]    DATETIME         NULL,
    [UpTime]        DATETIME         NULL,
    [CompanyId]     INT              CONSTRAINT [DF_Notice_CompanyId] DEFAULT ((0)) NULL,
    [CompanyIdList] NVARCHAR (300)   NULL,
    CONSTRAINT [PK_Notice] PRIMARY KEY CLUSTERED ([id] ASC)
);

